Learn how to use calculation groups and how they work internally. The whitepaper is a companion to the related SQLBI+ video course.  Read more

Visual calculations are a new feature in DAX that aims to simplify the use of DAX for users by introducing calculations at the visual level rather than at the model level.  Read more

white paper

The Many-to-Many Revolution

This white paper explores many different uses of many-to-many relationships in both SQL Server Analysis Services Multidimensional and Tabular models.  Read more

Learn the internals of Power BI semantic models created by using VertiPaq, DirectQuery over SQL, and DirectQuery for Power BI datasets and Analysis Services.  Read more

white paper

SSAS Tabular as Analytical Engine

This article describes the pros and cons of using SQL Server Analysis Services Tabular as the analytical engine in a service or application, based on the experience of companies who have adopted it.  Read more